﻿CREATE TABLE [dbo].[tblExportManager]
(
	ExportID int identity(1,1) NOT NULL, 
	OwnerID int not null,
	Name nvarchar(50) not null,
	ScheduleName nvarchar(100) not null,
	[FileName] nvarchar(100) not null,
	[Query] nvarchar(max) not null,
	Format varchar(10) not null,
	MailTo varchar(100) null,
	MailCc varchar(100) null,
	MailSubject nvarchar(400) null,
	MailBody nvarchar(2000) null,
	SendIfEmpty bit not null,
	AttachFile bit not null,
	AttachFileIfEmpty bit not null,
	OverwriteFile bit not null,
	FtpSite nvarchar(100) null,
	FtpDirectory nvarchar(500) null,
	FtpUser nvarchar(100) null,
	FtpPwd nvarchar(100) null,
	Active bit not null
)
